
create proc [dbo].[SP_SEL_PRODUCTS_GetPRO_NAME_By_Pro_ACC]
@PROTYP_ID int,
@ACC_ID int
as
select a.PRO_ID,a.PRO_NAME
from dbo.PRODUCTS a , dbo.PRODUCT_TYPES b
where  a.PROTYP_ID = b.PROTYP_ID 
and    b.PROTYP_ID=@PROTYP_ID
and    b.ACC_ID=@ACC_ID 


create proc [dbo].[SP_SEL_PRODUCTS_GetPRO_QUANTITY_By_Pro_ACC1]

@PRO_ID int,
@ACC_ID int
as
select a.PRO_ID , a.PRO_QUANTITY
from dbo.PRODUCTS a , dbo.PRODUCT_TYPES b
where  a.PROTYP_ID = b.PROTYP_ID 
and    b.ACC_ID=@ACC_ID
and    a.PRO_ID = @PRO_ID





